/*
 Navicat Premium Data Transfer

 Source Server         : yhjx
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : rm-bp1ng49sj5m0zp8m56o.mysql.rds.aliyuncs.com:3306
 Source Schema         : csnjadmin

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : 65001

 Date: 17/01/2020 11:01:30
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_element
-- ----------------------------
DROP TABLE IF EXISTS `sys_element`;
CREATE TABLE `sys_element` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) DEFAULT NULL COMMENT '资源编码',
  `type` varchar(255) DEFAULT NULL COMMENT '资源类型',
  `name` varchar(255) DEFAULT NULL COMMENT '资源名称',
  `uri` varchar(255) DEFAULT NULL COMMENT '资源路径',
  `menu_id` varchar(255) DEFAULT NULL COMMENT '资源关联菜单',
  `parent_id` varchar(255) DEFAULT NULL,
  `path` varchar(2000) DEFAULT NULL COMMENT '资源树状检索路径',
  `method` varchar(10) DEFAULT NULL COMMENT '资源请求类型',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `create_user` varchar(255) DEFAULT NULL,
  `create_uid` int(11) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `update_user` varchar(30) DEFAULT NULL,
  `update_uid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_element
-- ----------------------------
BEGIN;
INSERT INTO `sys_element` VALUES (3, 'userManager:btn_add', 'button', '新增', '/admin/user', '3', NULL, NULL, 'POST', '', NULL, NULL, NULL, '2020-01-17 10:58:18', NULL, NULL);
INSERT INTO `sys_element` VALUES (4, 'userManager:btn_edit', 'button', '编辑', '/admin/user/{*}', '3', NULL, NULL, 'PUT', '', NULL, NULL, NULL, '2020-01-17 10:58:19', NULL, NULL);
INSERT INTO `sys_element` VALUES (5, 'userManager:btn_del', 'button', '删除', '/admin/user/{*}', '3', NULL, NULL, 'DELETE', '', NULL, NULL, NULL, '2020-01-17 10:58:21', NULL, NULL);
INSERT INTO `sys_element` VALUES (9, 'menuManager:element', 'uri', '按钮页面', '/admin/element', '5', NULL, NULL, 'GET', '', NULL, NULL, NULL, '2020-01-17 10:58:50', NULL, NULL);
INSERT INTO `sys_element` VALUES (10, 'menuManager:btn_add', 'button', '新增', '/admin/menu/{*}', '5', NULL, NULL, 'POST', '', NULL, NULL, NULL, '2020-01-17 10:58:51', NULL, NULL);
INSERT INTO `sys_element` VALUES (11, 'menuManager:btn_edit', 'button', '编辑', '/admin/menu/{*}', '5', '', '', 'PUT', '', '2017-06-24 00:00:00', '', 0, '2020-01-17 10:58:52', NULL, NULL);
INSERT INTO `sys_element` VALUES (12, 'menuManager:btn_del', 'button', '删除', '/admin/menu/{*}', '5', '', '', 'DELETE', '', '2017-06-24 00:00:00', '', 0, '2020-01-17 10:58:54', NULL, NULL);
INSERT INTO `sys_element` VALUES (13, 'menuManager:btn_element_add', 'button', '新增元素', '/admin/element', '5', NULL, NULL, 'POST', '', NULL, NULL, NULL, '2020-01-17 10:58:55', NULL, NULL);
INSERT INTO `sys_element` VALUES (14, 'menuManager:btn_element_edit', 'button', '编辑元素', '/admin/element/{*}', '5', NULL, NULL, 'PUT', '', NULL, NULL, NULL, '2020-01-17 10:58:55', NULL, NULL);
INSERT INTO `sys_element` VALUES (15, 'menuManager:btn_element_del', 'button', '删除元素', '/admin/element/{*}', '5', NULL, NULL, 'DELETE', '', NULL, NULL, NULL, '2020-01-17 10:58:57', NULL, NULL);
INSERT INTO `sys_element` VALUES (16, 'groupManager:btn_add', 'button', '新增', '/admin/group', '6', NULL, NULL, 'POST', '', NULL, NULL, NULL, '2020-01-17 10:59:06', NULL, NULL);
INSERT INTO `sys_element` VALUES (17, 'groupManager:btn_edit', 'button', '编辑', '/admin/group/{*}', '6', NULL, NULL, 'PUT', '', NULL, NULL, NULL, '2020-01-17 10:59:07', NULL, NULL);
INSERT INTO `sys_element` VALUES (18, 'groupManager:btn_del', 'button', '删除', '/admin/group/{*}', '6', NULL, NULL, 'DELETE', '', NULL, NULL, NULL, '2020-01-17 10:59:08', NULL, NULL);
INSERT INTO `sys_element` VALUES (19, 'groupManager:btn_userManager', 'button', '分配用户', '/admin/group/{*}/user', '6', NULL, NULL, 'PUT', '', NULL, NULL, NULL, '2020-01-17 10:59:09', NULL, NULL);
INSERT INTO `sys_element` VALUES (20, 'groupManager:btn_resourceManager', 'button', '分配权限', '/admin/group/{*}/authority', '6', NULL, NULL, 'GET', '', NULL, NULL, NULL, '2020-01-17 10:59:10', NULL, NULL);
INSERT INTO `sys_element` VALUES (21, 'groupManager:menu', 'uri', '分配菜单', '/admin/group/{*}/authority/menu', '6', NULL, NULL, 'POST', '', NULL, NULL, NULL, '2020-01-17 10:59:11', NULL, NULL);
INSERT INTO `sys_element` VALUES (22, 'groupManager:element', 'uri', '分配资源', '/admin/group/{*}/authority/element', '6', NULL, NULL, 'POST', '', NULL, NULL, NULL, '2020-01-17 10:59:14', NULL, NULL);
INSERT INTO `sys_element` VALUES (23, 'userManager:view', 'uri', '查看', '/admin/user/{*}', '3', '', '', 'GET', '', '2017-06-26 00:00:00', '', 0, '2020-01-17 10:58:23', NULL, NULL);
INSERT INTO `sys_element` VALUES (24, 'menuManager:view', 'uri', '查看', '/admin/menu/{*}', '5', '', '', 'GET', '', '2017-06-26 00:00:00', '', 0, '2020-01-17 10:59:18', NULL, NULL);
INSERT INTO `sys_element` VALUES (27, 'menuManager:element_view', 'uri', '查看', '/admin/element/{*}', '5', NULL, NULL, 'GET', NULL, NULL, NULL, NULL, '2020-01-17 10:59:20', NULL, NULL);
INSERT INTO `sys_element` VALUES (28, 'groupManager:view', 'uri', '查看', '/admin/group/{*}', '6', NULL, NULL, 'GET', NULL, NULL, NULL, NULL, '2020-01-17 10:59:23', NULL, NULL);
INSERT INTO `sys_element` VALUES (32, 'groupTypeManager:view', 'uri', '查看', '/admin/groupType/{*}', '7', NULL, NULL, 'GET', '', NULL, NULL, NULL, '2020-01-17 10:59:34', NULL, NULL);
INSERT INTO `sys_element` VALUES (33, 'groupTypeManager:btn_add', 'button', '新增', '/admin/groupType', '7', NULL, NULL, 'POST', NULL, NULL, NULL, NULL, '2020-01-17 10:59:35', NULL, NULL);
INSERT INTO `sys_element` VALUES (34, 'groupTypeManager:btn_edit', 'button', '编辑', '/admin/groupType/{*}', '7', NULL, NULL, 'PUT', NULL, NULL, NULL, NULL, '2020-01-17 10:59:36', NULL, NULL);
INSERT INTO `sys_element` VALUES (35, 'groupTypeManager:btn_del', 'button', '删除', '/admin/groupType/{*}', '7', NULL, NULL, 'DELETE', NULL, NULL, NULL, NULL, '2020-01-17 10:59:37', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `request_url` varchar(100) NOT NULL,
  `request_param` text,
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_ip` varchar(20) NOT NULL,
  `module` varchar(20) DEFAULT NULL,
  `log_desc` varchar(100) DEFAULT NULL,
  `sysTime` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `user_name` varchar(20) NOT NULL,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=54786 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_log` VALUES (54778, 1, '/auth/token', '{\"username\":\"admin\",\"password\":\"123456\"}', '2020-01-17 10:41:28', '127.0.0.1', '认证', '系统登录', 780, 200, '系统管理员');
INSERT INTO `sys_log` VALUES (54779, 1, '/auth/token', '{\"username\":\"admin\",\"password\":\"123456\"}', '2020-01-17 10:44:16', '127.0.0.1', '认证', '系统登录', 818, 200, '系统管理员');
INSERT INTO `sys_log` VALUES (54780, 1, '/user/page', '{\"pageSize\":[\"20\"],\"pageNum\":[\"1\"]}', '2020-01-17 10:52:23', '127.0.0.1', '用户', '翻页查询', 401, 200, '系统管理员');
INSERT INTO `sys_log` VALUES (54781, 1, '/user/page', '{\"pageSize\":[\"20\"],\"pageNum\":[\"1\"]}', '2020-01-17 10:55:13', '127.0.0.1', '用户', '翻页查询', 80, 200, '系统管理员');
INSERT INTO `sys_log` VALUES (54782, 1, '/user/page', '{\"pageSize\":[\"20\"],\"pageNum\":[\"1\"]}', '2020-01-17 10:56:09', '127.0.0.1', '用户', '翻页查询', 72, 200, '系统管理员');
INSERT INTO `sys_log` VALUES (54783, 1, '/user/page', '{\"pageSize\":[\"20\"],\"pageNum\":[\"1\"]}', '2020-01-17 11:00:06', '127.0.0.1', '用户', '翻页查询', 64, 200, '系统管理员');
INSERT INTO `sys_log` VALUES (54784, 1, '/user/page', '{\"pageSize\":[\"20\"],\"pageNum\":[\"1\"]}', '2020-01-17 11:00:34', '127.0.0.1', '用户', '翻页查询', 89, 200, '系统管理员');
INSERT INTO `sys_log` VALUES (54785, 1, '/user/page', '{\"pageSize\":[\"20\"],\"pageNum\":[\"1\"]}', '2020-01-17 11:00:40', '127.0.0.1', '用户', '翻页查询', 79, 200, '系统管理员');
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) DEFAULT NULL COMMENT '路径编码',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `parent_id` int(11) NOT NULL COMMENT '父级节点',
  `href` varchar(255) DEFAULT NULL COMMENT '资源路径',
  `icon` varchar(255) DEFAULT NULL COMMENT '图标',
  `type` char(10) DEFAULT NULL,
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `path` varchar(500) DEFAULT NULL COMMENT '菜单上下级关系',
  `enabled` char(1) DEFAULT NULL COMMENT '启用禁用',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `create_user` varchar(255) DEFAULT NULL,
  `create_uid` int(11) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `update_user` varchar(255) DEFAULT NULL,
  `update_uid` int(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (1, 'adminSys', '管理后台', -1, '/base', 'list', 'dirt', 0, '', '/adminSys', NULL, NULL, NULL, NULL, '2020-01-17 10:46:26', '1', 18313);
INSERT INTO `sys_menu` VALUES (2, 'systemManager', '系统管理', 1, '/admin/adminSys', 'list', 'menu', 0, NULL, '/adminSys/systemManager', NULL, '2020-01-17 10:45:21', NULL, NULL, '2020-01-17 10:46:36', NULL, NULL);
INSERT INTO `sys_menu` VALUES (3, 'userManager', '用户管理', 2, '/admin/user', 'list', 'menu', 1, '', '/adminSys/baseManager/userManager', NULL, NULL, NULL, NULL, '2020-01-17 10:47:28', '1', 1270);
INSERT INTO `sys_menu` VALUES (4, 'syslogManager', '系统日志', 2, '/admin/syslog', 'list', 'menu', 2, NULL, '/adminSys/systemManager/syslogManager', NULL, NULL, NULL, NULL, '2020-01-17 10:47:29', NULL, NULL);
INSERT INTO `sys_menu` VALUES (5, 'menuManager', '菜单管理', 2, '/admin/menu', 'list', 'menu', 3, '', '/adminSys/systemManager/menuManager', NULL, NULL, NULL, NULL, '2020-01-17 10:51:09', '1', 1270);
INSERT INTO `sys_menu` VALUES (6, 'groupManager', '角色权限管理', 2, '/admin/group', 'list', 'menu', 4, '', '/adminSys/systemManager/groupManager', NULL, NULL, NULL, NULL, '2020-01-17 10:51:10', '1', 1270);
INSERT INTO `sys_menu` VALUES (7, 'groupTypeManager', '角色类型管理', 2, '/admin/groupType', 'list', 'menu', 5, '', '/adminSys/systemManager/groupTypeManager', NULL, NULL, NULL, NULL, '2020-01-17 10:51:11', '1', 1270);
COMMIT;

-- ----------------------------
-- Table structure for sys_resource_authority
-- ----------------------------
DROP TABLE IF EXISTS `sys_resource_authority`;
CREATE TABLE `sys_resource_authority` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `authority_id` varchar(255) DEFAULT NULL COMMENT '角色ID',
  `authority_type` varchar(255) DEFAULT NULL COMMENT '角色类型',
  `resource_id` varchar(255) DEFAULT NULL COMMENT '资源ID',
  `resource_type` varchar(255) DEFAULT NULL COMMENT '资源类型',
  `parent_id` varchar(255) DEFAULT NULL,
  `path` varchar(2000) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `create_user` varchar(255) DEFAULT NULL,
  `create_uid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1920 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_resource_authority
-- ----------------------------
BEGIN;
INSERT INTO `sys_resource_authority` VALUES (8, '1', 'group', '19', 'button', '-1', NULL, NULL, '2020-01-17 10:54:08', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (9, '1', 'group', '20', 'button', '-1', NULL, NULL, '2020-01-17 10:54:25', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (10, '1', 'group', '21', 'button', '-1', NULL, NULL, '2020-01-17 10:54:32', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (11, '1', 'group', '22', 'button', '-1', NULL, NULL, '2020-01-17 10:54:46', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (12, '1', 'group', '23', 'button', '-1', NULL, NULL, '2020-01-17 10:54:57', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1868, '1', 'group', '9', 'button', '-1', NULL, NULL, '2020-01-17 10:55:36', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1869, '1', 'group', '10', 'button', '-1', NULL, NULL, '2020-01-17 10:55:37', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1870, '1', 'group', '11', 'button', '-1', NULL, NULL, '2020-01-17 10:55:38', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1871, '1', 'group', '12', 'button', '-1', NULL, NULL, '2020-01-17 10:55:40', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1872, '1', 'group', '13', 'button', '-1', NULL, NULL, '2020-01-17 10:55:41', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1873, '1', 'group', '14', 'button', '-1', NULL, NULL, '2020-01-17 10:55:42', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1874, '1', 'group', '15', 'button', '-1', NULL, NULL, '2020-01-17 10:55:43', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1875, '1', 'group', '24', 'button', '-1', NULL, NULL, '2020-01-17 10:55:44', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1876, '1', 'group', '27', 'button', '-1', NULL, NULL, '2020-01-17 10:55:45', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1885, '1', 'group', '16', 'button', '-1', NULL, NULL, '2020-01-17 10:55:54', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1886, '1', 'group', '17', 'button', '-1', NULL, NULL, '2020-01-17 10:55:54', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1887, '1', 'group', '18', 'button', '-1', NULL, NULL, '2020-01-17 10:55:55', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1888, '1', 'group', '28', 'button', '-1', NULL, NULL, '2020-01-17 10:55:57', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1897, '1', 'group', '3', 'button', '-1', NULL, NULL, '2020-01-17 11:00:13', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1898, '1', 'group', '4', 'button', '-1', NULL, NULL, '2020-01-17 11:00:14', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1899, '1', 'group', '5', 'button', '-1', NULL, NULL, '2020-01-17 11:00:14', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1908, '1', 'group', '32', 'button', '-1', NULL, NULL, '2020-01-17 11:00:27', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1909, '1', 'group', '33', 'button', '-1', NULL, NULL, '2020-01-17 11:00:28', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1910, '1', 'group', '34', 'button', '-1', NULL, NULL, '2020-01-17 11:00:29', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1911, '1', 'group', '35', 'button', '-1', NULL, NULL, '2020-01-17 11:00:30', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1912, '1', 'group', '1', 'menu', '-1', NULL, NULL, '2020-01-17 11:00:31', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1913, '1', 'group', '2', 'menu', '-1', NULL, NULL, '2020-01-17 11:00:31', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1914, '1', 'group', '3', 'menu', '-1', NULL, NULL, '2020-01-17 11:00:31', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1915, '1', 'group', '4', 'menu', '-1', NULL, NULL, '2020-01-17 11:00:31', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1916, '1', 'group', '-1', 'menu', '-1', NULL, NULL, '2020-01-17 11:00:32', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1917, '1', 'group', '5', 'menu', '-1', NULL, NULL, '2020-01-17 11:00:32', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1918, '1', 'group', '6', 'menu', '-1', NULL, NULL, '2020-01-17 11:00:32', NULL, NULL);
INSERT INTO `sys_resource_authority` VALUES (1919, '1', 'group', '7', 'menu', '-1', NULL, NULL, '2020-01-17 11:00:32', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) DEFAULT NULL COMMENT '角色编码',
  `name` varchar(255) DEFAULT NULL COMMENT '角色名称',
  `parent_id` int(11) NOT NULL COMMENT '上级节点',
  `path` varchar(2000) DEFAULT NULL COMMENT '树状关系',
  `type` char(1) DEFAULT NULL COMMENT '类型',
  `group_type` int(11) NOT NULL COMMENT '角色组类型',
  `description` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `create_user` varchar(255) DEFAULT NULL,
  `create_uid` int(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `update_user` varchar(255) DEFAULT NULL,
  `update_uid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1, 'adminRole', '超级管理员', -1, '/adminRole', NULL, 1, '', NULL, NULL, NULL, '2018-09-13 17:36:58', '1', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_member
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_member`;
CREATE TABLE `sys_role_member` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(255) DEFAULT NULL,
  `user_id` int(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `create_user` varchar(255) DEFAULT NULL,
  `create_uid` int(11) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `update_user` varchar(255) DEFAULT NULL,
  `update_uid` int(11) DEFAULT NULL,
  `leader` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_role_member
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_member` VALUES (29, 1, 1, NULL, '2018-11-22 18:22:33', NULL, NULL, NULL, NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_type`;
CREATE TABLE `sys_role_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) DEFAULT NULL COMMENT '编码',
  `name` varchar(255) DEFAULT NULL COMMENT '类型名称',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_uid` int(11) DEFAULT NULL COMMENT '创建人ID',
  `create_user` varchar(255) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  `update_user` varchar(255) DEFAULT NULL COMMENT '最后更新人ID',
  `update_uid` int(11) DEFAULT NULL COMMENT '最后更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_role_type
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_type` VALUES (1, 'role', '角色类型', '实际角色', NULL, NULL, NULL, '2017-08-25 17:52:37', '1', 0);
INSERT INTO `sys_role_type` VALUES (3, 'biz', '业务类型', '虚拟角色', NULL, NULL, NULL, '2018-09-13 17:40:37', '1', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) DEFAULT NULL COMMENT '用户名',
  `password` varchar(140) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `birthday` varchar(20) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(30) DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  `description` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `create_uid` int(12) DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `update_uid` int(32) DEFAULT NULL,
  `update_user` varchar(30) DEFAULT NULL,
  `create_user` varchar(30) DEFAULT NULL,
  `login_ip` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, 'admin', '$2a$12$UZmCsx8AJULkRoKMqFOAi.EjxIRVe5nmQvaNxv2n0xR1NovHZsE3.', '系统管理员', NULL, NULL, NULL, NULL, 0, NULL, '2018-11-22 11:45:57', NULL, '2020-01-17 10:44:16', 1, '系统管理员', NULL, '127.0.0.1');
INSERT INTO `sys_user` VALUES (24, 'test', '$2a$12$A.ycg2RaRlkBkRAEaPR0/euQWTTNWWCHa711.boMHmLMZaWs1y9fC', '测试用户', NULL, NULL, NULL, NULL, 0, 'test123', '2018-11-22 15:01:53', NULL, '2018-11-22 15:02:15', NULL, NULL, NULL, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
